Load Fact Table 13
For the Fact Table DFT, go to the Data Flow tab. We will use Lookups since we won't be dealing with over 50,000 rows. We'll be connecting with tables on the Colaberry app.
The following is the SELECT statement for the OLE DB Source named "JoiningDimTables".
SELECT distinct A.VideoContentKey, D.StudentDetailKey, A.VideoId, E.LibraryKey, A.UVG_ID
FROM [dbo].[Dim_VideoDetails] A
left outer join [dbo].[Dim_Student] D on D.StudentUserId = A.CreatedByUser
Left outer join [dbo].[Dim_LibraryCategory] E on E.LibraryId = A.LibraryId
10) Add the Keys from the attached SQL file after the Fact Table has been loaded. You are welcome to use an Execute SQL Task for truncating and removing these Surrogate Keys at the beginning of the package, but remember that truncating a Data Warehouse is generally bad practice.
What is a fact table and what are they to a data warehouse?
https://www.edureka.co/blog/fact-table-and-its-types-in-data-warehousing/